package demo;

import java.sql.*;


public class DisplayOrderForm
{
	
	public static String getOrderFormInfo(String OrderStatus)
	{
		DBConnector db = DBConnector.getDBConnector();		
		String Rest_ID = RestaurantQuery.getRestaurantSelected();
		
		String statement = "select form_ID, cus_name, form_time, form_state from order_form, customer where customer.cus_ID = order_form.cus_ID and form_state = '" + OrderStatus + "'";
		db.prepareStatement(statement);
		ResultSet FoodInfo = db.queryPstmt();
		
		StringBuffer sBuf = new StringBuffer();
		sBuf.append(OrderStatus);
		//sBuf.append("<table width = 100% align = center border = 1><tr>");
		return sBuf.toString();	
	}	
}